Problem Note 36294: Special characters in column names might cause errors when importing data in SAS® Enterprise Guide®
 |  |  |  |
Import Data task might fail with an error similar to the following:
ERROR: Variable My_Var is not on file WORK.BOOK1.
This error will most likely occur only with Excel or Microsoft Access data. In addition, the error can happen when the column name has special characters or embedded spaces, and the following two options are selected in the Import Data task:
Rename columns to comply with SAS naming conventions.
Import the data using SAS/ACCESS Interface to PC Files whenever possible.
The only circumvention to the problem is to not use these options for the particular file being imported, or manually remove the special characters in the data file before importing.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-06-25 14:45:55 |
| Date Created: | 2009-06-19 15:18:42 |